Show:
Today's Messages
:: Unanswered Messages :: Polls
:: Message Navigator
|
15 Search Results Found |
1 |
Forum: Performance Tuning «»
Posted on: Wed, 23 November 2011 10:03 «»
By: mjm22
parallel_index
…(UNIQUE) PARALLEL_COMBINED_WITH_PARENT ARBOR.CDR_UNBILLED_PK :Q1000Cost: 11 K Bytes: 122 M Cardinality: 9 M
3 INDEX RANGE SCAN INDEX (UNIQUE) PARALLEL_COMBINED_WITH_PARENT ARBOR.CDR_DATA_PK :Q1000Cost: 3 Cardinality: 1
5 TABLE ACCESS BY…
|
2 |
Forum: JDeveloper, Java & XML «»
Posted on: Wed, 25 February 2009 20:44 «»
By: wmgonzalbo
Java, PL/SQL Proc
…i did these steps:
$ loadjava -user arbor Myclass.class
Password: password
SQL> EXECUTE DBMS_JAVA.GRANT_PERMISSION ('MYSHEMA', 'SYS:java.io.FilePermission', '<<ALL FILES>>', 'execute' )
PL/SQL procedure successfully …
|
3 |
Forum: Marketplace «»
Posted on: Tue, 23 September 2008 11:55 «»
By: bushas
Oracle Applications DBA Position in Midwest U.S.
…/12 experience
Location: Between Ann Arbor Michigan and Toledo Ohio
Salary/Wage:95,000.00 - 105,000.00 /year Full Time, Employee
Relocation Assistance is provided.
*Description:
Oracle Applications DBA will be responsible for …
|
4 |
Forum: Server Utilities «»
Posted on: Tue, 06 May 2008 10:25 «»
By: rodpd
Re: SQL*Loader-282: Unable to locate character set handle for character set ID (871).
…/product/10.2.0.1
#setenv ORACLE_HOME /usr1/arbor/3poracle/HPUX
setenv PATH ${ORACLE_HOME}/bin:${PATH}
setenv SHLIB_PATH ${ORACLE_HOME}/lib:${SHLIB_PATH}
setenv LD_LIBRARY_PATH ${ORACLE_HOME}/lib:${LD_LIBRARY_PATH}
You then switch back to 3p …
|
5 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 20 March 2008 15:46 «»
By: r0bert
ORA-00904: invalid column name--HELP! query is working in pl/sqldev tool but not in shell script
… (select external_id_type from arbor.external_id_type_values
where display_value like ''%Outlet ID%''
or external_id_type=2007)
and id_no in…
|
6 |
Forum: Server Utilities «»
Posted on: Mon, 15 October 2007 05:16 «»
By: Michel Cadot
Re: Rollback in Sql * loader
Connect as the OS oracle instance owner and execute:
$ id
$ groups
$ ps -eaf | grep smon
$ head /arbor1/arbor/Rohit/a.dat
Regards
Michel
|
7 |
Forum: Server Utilities «»
Posted on: Mon, 15 October 2007 04:32 «»
By: rk1982
Re: Rollback in Sql * loader
…acess to directory.
resolve my problem
arbor@billdev:/arbor1/arbor/Rohit 102 : ls -l a.dat
-rwxrwxrwx 1 arbor arboradm 176 Oct 11 23:48 a.dat
arbor@billdev:/arbor1/arbor/Rohit 103 :
arbor@billdev:/oracle/product/9206 112 :
[mod-…
|
8 |
Forum: Server Utilities «»
Posted on: Mon, 15 October 2007 03:59 «»
By: rk1982
Re: Rollback in Sql * loader
…the direcotory name
xtern_data_dir as '/arbor1/arbor/Rohit' but a.dat is present in this path /arbor1/arbor/Rohit
Can you suggest me the possible reason of this.
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error…
|
9 |
Forum: Replication «»
Posted on: Wed, 20 September 2006 21:32 «»
By: kareem2020
snapshot refresh in parallel stream
…refresh for a snapshot table in 4 parallel streams. But its run only as normal stream(single). what may be wrong? or any statement syntax?. Already parallelism is activated.
execute dbms_snapshot.refresh('arbor.rate_usage','C','R01',FALSE,FALSE,0,4…
|
10 |
Forum: Performance Tuning «»
Posted on: Thu, 27 July 2006 06:54 «»
By: michael_bialik
Re: Pl/sql procedure experience a high parse count using oracle 9i db-link.
…
from rlc_tmp rt, RL_ACCOUNTS ra, CMF@arbor9ioff CMF_KA
WHERE ra.accountid(+) = rt.accountid AND
CMF_KA.ACCOUNT_NO(+) = RA.TMA_CMF_11 ;
v_accountno NUMBER(10);
BEGIN
FOR R IN C LOOP
if R.ACCOUNT_NO is null then
dbms_output…
|
11 |
Forum: Performance Tuning «»
Posted on: Thu, 27 July 2006 02:46 «»
By: Josepha
Pl/sql procedure experience a high parse count using oracle 9i db-link.
…
INTO v_accountno
FROM RL_ACCOUNTS, CMF@arbor9ioff CMF_KA
WHERE RL_ACCOUNTS.ACCOUNTID = R.ACCOUNTID
AND
CMF_KA.ACCOUNT_NO = RL_ACCOUNTS.TMA_CMF_11;
insert into jjoff(my_account) values(v_accountno);
commit;
END LOOP;
exception …
|
12 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 15 April 2003 08:11 «»
By: Mike
PL/SQL ERROR
…transtype, '', NULL, NULL, NULL, '', '','', 'arbor2','APP', '', '', NULL, NULL, NULL, '', NULL,v_transamt,v_transamt, 2,NULL,NULL, NULL, 1, NULL, NULL, '',v_annotation, NULL, NULL, 0, 0 );
update xx_payments_CAM
…
|
13 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 14 April 2003 23:20 «»
By: Mike
Help Required in PL/SQL Block
…transtype, '', NULL, NULL, NULL, '', '','', 'arbor2','APP', '', '', NULL, NULL, NULL,
'', NULL,v_transamt,v_transamt, 2,NULL,NULL, NULL, 1, NULL, NULL, '',v_annotation, NULL,
NULL, 0, 0 );
update XX_PAYMENTS_1504
set tracking_id = (select tracking_id …
|
14 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 14 April 2003 23:09 «»
By: Mike
Help required in PL/SQL Block
…transtype, '', NULL, NULL, NULL, '', '','', 'arbor2','APP', '', '', NULL, NULL, NULL,
'', NULL,v_transamt,v_transamt, 2,NULL,NULL, NULL, 1, NULL, NULL, '',v_annotation, NULL,
NULL, 0, 0 );
update XX_PAYMENTS_1504…
|
15 |
Forum: Marketplace «»
Posted on: Wed, 17 November 1999 17:40 «»
By: Doug Keller
Oracle programmers and DBA
Need Oracle programmers and DBAs with SQl, FOrm and reports. Immediately. Michigan and Ann arbor area.
Thank you, D Keller
|
Current Time: Thu Sep 12 06:20:53 CDT 2024
|